Java jdbc连接mysql

来源：互联网发布：恢复删除软件要钱编辑：程序博客网时间：2024/06/05 16:54
package com.jdbcDemo;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class JDBCDemo {    public static Connection getDataBaseConnection(){        String driver = "com.mysql.jdbc.Driver";        String url = "jdbc:mysql://localhost:3306/demo?characterEncoding=utf-8";        String user = "root";        String password = "root";        Connection conn = null;        PreparedStatement stmt = null;        ResultSet rs = null;        //加载驱动程序        try {            Class.forName(driver);            System.out.println("驱动程序加载成功...");        } catch (ClassNotFoundException e) {            e.printStackTrace();        }        //连接数据库        try {            conn = DriverManager.getConnection(url,user,password);            if(!conn.isClosed()){                System.out.println("数据库连接成功...");            }        } catch (SQLException e) {            System.out.println("数据库连接失败："+ e.getMessage());        }        //查询        try {            stmt = conn.prepareStatement("SELECT * FROM demo where name = ?");            stmt.setString(1, "zhangsan");            rs = stmt.executeQuery();            while(rs.next()){                System.out.println(rs.getString("id"));                System.out.println(rs.getString("name"));                System.out.println("-------------------");            }        } catch (SQLException e1) {            // TODO Auto-generated catch block            e1.printStackTrace();        }finally {                try {                    if(rs != null){                        rs.close();                    }                    if (stmt != null) {                        stmt.close();                    }                    if(conn != null){                        conn.close();                    }                    System.out.println("数据库关闭成功...");                } catch (SQLException e) {                    // TODO Auto-generated catch block                    e.printStackTrace();                }        }        return conn;    }    public static void main(String [] args){        JDBCDemo.getDataBaseConnection();    }}
阅读全文
1 0