JDBC访问MySQL数据库

来源：互联网发布：机械常最用有限元软件编辑：程序博客网时间：2024/04/20 11:33

1.下载所需的Connector/j版本

2.正确安装MySQL数据库

3.编写编码，进行测试

package connection.mysql;import java.io.UnsupportedEncodingException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class Demo {public static void main(String[] args) {//从学生表当中获取信息DBHelper db = new DBHelper("select * from stu");ResultSet set = null;try {set = db.pst.executeQuery();while(set.next()){System.out.println(set.getString(1));System.out.println(set.getString(2));System.out.println(new String(set.getBytes(3), "gbk"));System.out.println(set.getString(4));}db.close();} catch (SQLException e) {e.printStackTrace();} catch (UnsupportedEncodingException e) {e.printStackTrace();}}}class DBHelper{//数据库连接字符串public static final String url = "jdbc:mysql://localhost/test";//驱动程序类public static final String driver = "com.mysql.jdbc.Driver";//用户名public static final String user = "root";//密码public static final String password = "225821";//连接对象和预处理语句public Connection conn = null;public PreparedStatement pst = null;//构造器public DBHelper(String sql){try {//加载驱动程序类Class.forName(driver);//连接到数据库conn = DriverManager.getConnection(url, user, password);pst = conn.prepareStatement(sql);} catch (Exception e) {close();e.printStackTrace();}}public void close(){if(pst != null){try {pst.close();} catch (SQLException e) {e.printStackTrace();}}if(conn != null){try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}}

0 0