jdbc访问MySql基本类

最新推荐文章于 2022-04-18 08:00:00 发布

explorewen

最新推荐文章于 2022-04-18 08:00:00 发布

阅读量514

点赞数

分类专栏： java笔记文章标签： jdbc mysql exception string sql url

本文链接：https://blog.csdn.net/explorewen/article/details/2781675

版权

java笔记专栏收录该内容

14 篇文章 0 订阅

订阅专栏

package msg.impl;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;

public class DbOperation {
public DbOperation(){}
private static Statement st;
private static Connection con;
public void init(String databaseName,String userName,String userPassWord){
  String driver="com.mysql.jdbc.Driver";
  String url="jdbc:mysql://localhost:3306/"+databaseName+"?user="+userName+"&password="+userPassWord;
  try{
  if(con!=null)return;
  Class.forName(driver);
  con=DriverManager.getConnection(url);
  st=con.createStatement();
  }catch(Exception e){
   System.out.println(e);
  }
}

public void executeUpdate(String sql){
  try {
   st.execute(sql);
  } catch (Exception e) {
   System.out.println(e);
  }
}

public ResultSet executeQuery(String sql){
  ResultSet rs=null;
  try {
   rs = st.executeQuery(sql);
  } catch (Exception e) {
   System.out.println(e);
  }
  return rs;
}

public void destroy(){
  try{
  st.close();
  con.close();
  }catch(Exception e){
   System.out.println(e);
  }
}
}