Java 连接数据库、执行SQL封装类
/*当执行SQL时发现不能连接数据库,先重连一次*/
import java.io.FileInputStream;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import java.util.TimerTask;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.ImageIcon;
import javax.swing.JOptionPane;
class SQL_OPERATION_TRAN {
//private Connection cn;
private PreparedStatement pst;
private ResultSet rs;
private boolean isAutoCommit=true;
private CallableStatement proc;
java.util.Timer tmReceive;
//int counter=0;
Main gbl_Main;
SQL_OPERATION_TRAN(Main main){
//cn=connection;
gbl_Main=main;
//this.CheckConnect();
// this.Connect();
}
public void Connect(){
//gbl_Main.cn=gbl_Main.con.getConnection();
String name = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://10.10.10.10:1433;DatabaseName=aa";
String username = "bb";
String password = "cc";
try {
Class.forName(name);
try {
gbl_Main.cnTran = DriverManager.getConnection(url, username, password);
//DriverManager.setLoginTimeout(30000);
gbl_Main.gbl_ErrorCounter = 0;
gbl_Main.gbl_TryCounter = 0;
System.out.println("Connect="+gbl_Main.gbl_ErrorCounter);
} catch (SQLException ex) {
gbl_Main.gbl_ErrorCounter++;
Logger.getLogger(SQL_OPERATION.class.getName()).log(Level.SEVERE, null, ex);
}
} catch (ClassNotFoundException ex) {
Logger.getLogger(SQL_OPERATION.class.getName()).log(Leve
相关文档:
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.io.IOException;
import java.io.Serializable;
import java.rmi.Na ......
1.不用退出SQL2000安装程序,直接切换到桌面.
2.打开注册表编辑器(在“运行”中敲入“regedit”之后回车即可),定位到注册表的HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager节点.
3.单击“Session Manager”这个节点, ......
第一种:
public void deleteUser(String byemail) {
Session session = getSession();
Transaction transaction = null;
String hql = "delete from Register where email=?
";
try {
transaction = session.beginTransactio ......
一、使用参数化输入。存储过程里尽量避免语句拼接。
二、对于一些数据库,必须设置权限,甚至设置到字段。
三、始终通过测试类型、长度、格式和范围来验证用户输入。
四、过滤敏感字符。
Function ReplaceStr(Str)
Str=Trim(Str)
Str=Replace(Str,"'","'")
Str=Replace(Str,";",";")
Str=Rep ......