以下是连接mysql的一个源代码例子:import java.sql.*;public class TestMySql{
public static void main(String[] args) throws SQLException{
MySqlConn con=new MySqlConn();
ResultSet rs=con.getCustomers();
while(rs.next()){
System.out.println("name=" + rs.getString("NAME"));
}
}
}
class MySqlConn{
String DBDriver="org.gjt.mm.mysql.Driver";//驱动类名
String ConnStr="jdbc:mysql://localhost:3306/tester";//数据库连接url
Connection conn=null;
ResultSet rs=null;
public MySqlConn(){
try{
Class.forName(DBDriver);//注册驱动类
}catch(Exception e){
System.out.println("initialized exception::" + e.getMessage());
}
}
public ResultSet getCustomers(){
String sql="select * from customer order by name";
try{
conn=DriverManager.getConnection(ConnStr,"test","test");//获得数据库连接
System.out.println("connection successfully!");
Statement stmt=conn.createStatement();//获取执行语句
rs=stmt.executeQuery(sql);//执行sql查询
}catch(Exception e){
System.out.println(e.getMessage());
}
return rs;
}
}
把取出的resultset数据放在JList或者JTable.
public static void main(String[] args) throws SQLException{
MySqlConn con=new MySqlConn();
ResultSet rs=con.getCustomers();
while(rs.next()){
System.out.println("name=" + rs.getString("NAME"));
}
}
}
class MySqlConn{
String DBDriver="org.gjt.mm.mysql.Driver";//驱动类名
String ConnStr="jdbc:mysql://localhost:3306/tester";//数据库连接url
Connection conn=null;
ResultSet rs=null;
public MySqlConn(){
try{
Class.forName(DBDriver);//注册驱动类
}catch(Exception e){
System.out.println("initialized exception::" + e.getMessage());
}
}
public ResultSet getCustomers(){
String sql="select * from customer order by name";
try{
conn=DriverManager.getConnection(ConnStr,"test","test");//获得数据库连接
System.out.println("connection successfully!");
Statement stmt=conn.createStatement();//获取执行语句
rs=stmt.executeQuery(sql);//执行sql查询
}catch(Exception e){
System.out.println(e.getMessage());
}
return rs;
}
}
把取出的resultset数据放在JList或者JTable.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货