jdbc连接数据库并打印的简单例子

6步连接数据库:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class HelloServlet {
    public static void main(String[] args) throws Exception{
        test();
    }
    static void test() throws SQLException, ClassNotFoundException {
        // 1.注册驱动
        Class.forName("com.mysql.jdbc.Driver");//推荐方式
        // 2.建立连接
        String url = "jdbc:mysql://localhost:3306/test";//数据库名
        String user = "root";
        String password = "root";
        Connection conn = DriverManager.getConnection(url, user, password);
        // 3.创建语句
        Statement st = conn.createStatement();
        // 4.执行语句
        ResultSet rs = st.executeQuery("select * from user");
        // 5.处理结果
        while (rs.next()) {
            System.out.println(rs.getObject(1) + "\t" + rs.getObject(2));
        }
        // 6.释放资源
        rs.close();
        st.close();
        conn.close();
    }
}

优化:

https://www.cnblogs.com/justlove/p/6946032.html

 

posted @ 2018-03-05 21:07  leerle  阅读(428)  评论(0)    收藏  举报