JDBC初始化流程

最新推荐文章于 2024-10-31 16:55:17 发布

Mongo七七

最新推荐文章于 2024-10-31 16:55:17 发布

阅读量569

点赞数

文章标签： jdbc

本文链接：https://blog.youkuaiyun.com/guojinpeng1/article/details/50679704

版权

public Test{
 private String driver = "com.mysql.jdbc.Driver";
 private String url = "jdbc:mysql://localhost:3306/dbname?useUnicode=true&charactorEncoding=utf-8";
 private String username = "root";
 private String password = "";
 private Connection conn = null;
 private Statement st = null;
 private ResultSet rs = null;
 
 public void init(){
  try{
   Class.forName(driver);
   conn = DriverManager.getConnection(url,username,password);
   st = conn.createStatement();
  }catch(){}
 }
  
 public void test(){
  String sql = "select..........";
  rs =st.executeQuery(sql);
 }
 
 public void destory(){
  rs.close();
  st.close();
  conn.close();
 }
}