dataconn.java

来自「这个是由于项目需要」· Java 代码 · 共 93 行

import java.sql.*;
public class DataConn 
{
   private String driveName;
   private String userName;
   private String userPassword;
   private String dbName;
   private String url;
   private Statement st;
   protected ResultSet rs;
   private PreparedStatement pt;
   protected Connection conn;
   public DataConn()
   {
	   driveName="com.mysql.jdbc.Driver";
	   userName="root";
	   userPassword="123";
	   dbName="smail";
	   url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPassword;
	   try
	   {
		   Class.forName("com.mysql.jdbc.Driver").newInstance();
		   Connection conn=DriverManager.getConnection(url);
		   st=conn.createStatement();
	   }
	   catch(Exception e)
	   {
	   }
   }
   public ResultSet SqlQuery(String sql)
   {
	   try
	   {
		   rs=st.executeQuery(sql);
	   }
	   catch(Exception e)
	   {

	   }
	   return rs;
   }
   public boolean SqlInsert(String sql)
   {
	   try
	   {
	      st.executeUpdate(sql);
	      return true;
	   }
	   catch(Exception e)
	   {
		   return false;
	   }
	   
   }
   public boolean SqlDelete(String sql)
   {
	   try
	   {
           st.executeUpdate(sql);
           return true;
		   //st.close();
		   //conn.close();
	   }
	   catch(Exception e)
	   {
		   return false;
	   }
   }
   public boolean SqlUpdate(String sql)
   {
	   try
	   {
		   st.executeUpdate(sql);
		  // st.close();
		   return true;
	   }
	   catch(Exception e)
	   {
		   return false;
	   }
   }
   public void DisConn()
   {
	   try
	   {
		   conn.close();
	   }
	   catch(Exception e)
	   {}
   }

}