jdbc连接mysql——经典java小程序

来源：互联网发布：oracle 11 linux rpm 编辑：程序博客网时间：2024/05/12 10:13

根据出处：http://yqsshr.blog.51cto.com/469059/106891 稍作修改

一、在eclipse中新建java project 名为jdbctest；

二、右键项目名称-->buildpath-->configure build path-->add external jars;添加mysql驱动jar包mysql_connector_java_5.1.29_bin.jar

二、在src中新建类Jdbc，其中数据库的用户名密码以及select语句需要根据实际情况修改；

package jdbcTest;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Jdbc { public static void main(String[] args) {  Connection conn = null;  Statement stmt = null;  ResultSet rs = null;  String url = null;  String user = null;  String password = null;  String sql = null;  try {   Class.forName("com.mysql.jdbc.Driver"); //加载mysq驱动  } catch (ClassNotFoundException e) {   System.out.println("驱动加载错误");   e.printStackTrace();//打印出错详细信息  }  try {   url =     "jdbc:mysql://localhost/mydb?user=root&password=yqs2602555&useUnicode=true&&characterEncoding=gb2312&autoReconnect = true";//简单写法：url = "jdbc:myqsl://localhost/test(数据库名)? user=root(用户)&password=yqs2602555(密码)";   user = "root";   password = "";   conn = DriverManager.getConnection(url,user,password);  } catch (SQLException e) {   System.out.println("数据库链接错误");   e.printStackTrace();  }  try {   stmt = conn.createStatement();   sql = "select * from privilege_value";   rs = stmt.executeQuery(sql);//执行sql语句   while(rs.next()) {    System.out.print(rs.getInt("code") + "   ");    System.out.print(rs.getString("value") + "   ");   }  } catch (SQLException e) {   System.out.println("数据操作错误");   e.printStackTrace();  }//关闭数据库  try {   if(rs != null) {    rs.close();    rs = null;   }   if(stmt != null) {    stmt.close();    stmt = null;   }   if(conn != null) {    conn.close();    conn = null;   }  } catch(Exception e) {   System.out.println("数据库关闭错误");   e.printStackTrace();  } }}

0 0