Java+mysql连接

1、将mysql驱动包复制到 myeclips中WEB-INF下的lib目录下。

2.导入相应的包

3.定义数据库连接需要的常量

  public static final String DBDRIVER = "com.mysql.jdbc.Driver";
 public static final String DBNAME = "mydb";
 public static final String DBUSER = "root";
 public static final String DBPASSWORD = "123456";
 public static final String URL ="jdbc:mysql://localhost/"+DBNAME+"?user="+DBUSER+"&password="+DBPASSWORD;

4.定义连接

Connection conn = null;
 Statement st = null;           //定义一个Statement实例用来执行数据库操作
 ResultSet rs = null;           //用来存放结果集

5.加载驱动

  Class.forName(DBDRIVER);//加载驱动
  conn = DriverManager.getConnection(url);//建立连接
  st = conn.createStatement();
  String sql = "select * from user";
  rs = st.executeQuerty(sql);

6.if(rs.next()){ ...................

}

 public static final String DBDRIVER="com.mysql.jdbc.Driver";
 public static final String dbName="mydb";
 public static final String DBUSER="root";
 public static final String DBPASSWORD="123456";
 public static final String DBURL="jdbc:mysql://localhost/"+dbName+"?user="+DBUSER+"&password="+DBPASSWORD;

java.sql.Connection conn = null;
 java.sql.PreparedStatement pstmt = null;
 ResultSet rs = null;

Class.forName(DBDRIVER);
  conn = DriverManager.getConnection(DBURL);
  pstmt.setString(1,"userid");                       
  pstmt.setString(2,"password");
  String sql = "SELECT userid,name FROM user where userid=? and password=?";
  rs = pstmt.executeQuery(sql);