package database;

 
import java.sql.*;
 
import javax.swing.JOptionPane;
public class JDBC_CONNECTION {
 
//驱动名
private String driversql = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String driverjtds = "net.sourceforge.jtds.jdbc.Driver";
private String url = "jdbc:sqlserver://localhost:1433;databaseName=Address_Book";
//"jdbc:sqlserver://localhost:2433;databaseName=Address_Book","sa","admin!@#$%^!!"
//"jdbc:jtds:sqlserver://localhost:1433/YGGL","sa","123456"
//服务器名
int count;
int pcout;
public ResultSet rs = null;
public Connection con = null;
public Statement stat = null;
public PreparedStatement pstat = null;
//private String psql = "INSERT INTO TXL(name,picture) VALUES('小屋1',?)";
//建立连接
public void connectDB()
{
try {
Class.forName(driversql);
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=Address_Book","sa","123456");
stat = con.createStatement();
//pstat = con.prepareStatement(psql);
} catch (Exception e) {
// TODO Auto-generated catch block
JOptionPane.showMessageDialog(null, "数据库连接失败！","错误提示",JOptionPane.ERROR_MESSAGE);
e.printStackTrace();
}
}
//preparedStatement
public void pstconnectDB(String sql)
{
try {
Class.forName(driversql);
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=Address_Book","sa","123456");
pstat = con.prepareStatement(sql);
} catch (Exception e) {
// TODO Auto-generated catch block
JOptionPane.showMessageDialog(null, "数据库连接失败！","错误提示",JOptionPane.ERROR_MESSAGE);
e.printStackTrace();
}
}
//查询
public void selectDB(String sql)
{
try {
rs = stat.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
JOptionPane.showMessageDialog(null, "查询失败！","错误提示",JOptionPane.ERROR_MESSAGE);
e.printStackTrace();
}
}
//更新
public int updateDB(String sql)
{
try
{
count = stat.executeUpdate(sql);
}
catch(SQLException e)
{
JOptionPane.showMessageDialog(null, "更新失败！","错误提示",JOptionPane.ERROR_MESSAGE);
e.printStackTrace();
}
return count;
}
//关闭
public void close()
{
try
{
rs.close();
stat.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void pstatclose()
{
try
{
rs.close();
pstat.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}