mysql java连接视频_【自制视频】Java连接MySQL

package myweb6;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class ConnDB {

private Connection cn;

private Statement stmt;

private ResultSet rs;

public boolean open(String host,String dbname,String sUsr,String sPwd){

try{

//加载驱动

Class.forName("com.mysql.jdbc.Driver");

String url="jdbc:mysql://"+host+":3306"+"/"+dbname;

cn = DriverManager.getConnection(url, sUsr, sPwd);

stmt=cn.createStatement();

}catch(ClassNotFoundException e){

e.printStackTrace();

return false;

} catch (SQLException e) {

e.printStackTrace();

}

return true;

}

public boolean close(){

try{

cn.close();

stmt.close();

rs.close();

}catch(SQLException sqlex){

sqlex.printStackTrace();

return false;

}

return true;

}

public ResultSet executeQuery(String sql){

try {

rs=stmt.executeQuery(sql);

} catch (SQLException sqlex) {

sqlex.printStackTrace();

return null;

}

return rs;

}

/**

* @param args

*/

public static void main(String[] args) {

ConnDB c=new ConnDB();

c.open("localhost","dbtest","root","root");

ResultSet rs=c.executeQuery("select * from tb_test");

try {

while(rs.next()){

System.out.println(rs.getString("uid")+" : "+rs.getString("pwd"));

}

} catch (SQLException sqlex) {

sqlex.printStackTrace();

}

System.out.println("Main() success~~");

c.close();

}

}