mysql连接数据库的优化（一次连接多次使用）

直接上码

获得连接

import java.sql.Connection; 
import java.sql.DriverManager;
import java.sql.ResultSet;
public class Dbcon  
{
//Dbc dcp=new Dbc();
 public Connection getConnection(){
  Connection conn = null ;
  try{
   Class.forName("com.mysql.jdbc.Driver") ;
   
   conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/obu", "root", "123") ;
  // dcp.setcon(conn);
  System.out.println(conn);
   return conn ;
  }catch(Exception e){
   e.printStackTrace() ;
  }
  return null ;
 }
}

读取数据

import java.sql.Connection; 
import java.sql.DriverManager;
import java.sql.ResultSet;


public class Dbconnect {
 public Dbconnect(){
  try{
 Dbcon dcp2=new Dbcon();
     
//System.out.println(dcp.getcon());
java.sql.Statement statement =dcp2.getConnection().createStatement();
String sql = "select * from kb_203";
ResultSet rs = statement.executeQuery(sql);
String name;
while (rs.next()) 
{
System.out.println(rs.getString(1));

}
rs.close();
//conn.close();

}
catch(Exception ex){
ex.printStackTrace();
}
finally{


}


}
}

测试类

public class Testdb 
{
public static void main(String[] args) 
{
new Dbconnect();

}
}