- public class Base {
- public static void main(String[] args) throws Exception {
- // TODO Auto-generated method stub
- template();
- }
- static void template() throws Exception
- {
- Connection conn=null;
- Statement st=null;
- ResultSet resultset=null;
- try {
- //2.建立连接
- conn=JdbcUtils.getConnection();
- //3.创建语句
- st=conn.createStatement();
- //4.执行语句
- resultset=st.executeQuery("select *from user");
- //5.处理结果
- while(resultset.next())
- {
- System.out.println(resultset.getObject(1));
- System.out.println(resultset.getObject(2));
- System.out.println(resultset.getObject(3));
- System.out.println(resultset.getObject(4));
- }
- } finally
- {
- JdbcUtils.free(resultset, st, conn);
- }
- }}
- public class JdbcUtils
- {
- private static String url="jdbc:mysql://localhost:3306/jdbc";
- private static String user="root";
- private static String password="123";
- private JdbcUtils()
- {
- }
- static
- {
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- }
- catch(ClassNotFoundException e)
- {
- throw new ExceptionInInitializerError(e);
- }
- }
- public static Connection getConnection() throws SQLException
- {
- return DriverManager.getConnection(url, user, password);
- }
- public static void free(ResultSet resultset,Statement st,Connection conn)
- {
- //6.释放资源
- try{
- if(resultset!=null)
- resultset.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- finally
- {
- try
- {
- if(st!=null)
- st.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- finally
- {
- if(conn!=null)
- try {
- conn.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }
- }
- }
JDBC小小实例教程
最新推荐文章于 2024-06-30 02:15:42 发布