代码如下
package um.util.lzt;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Data {
public Data(){
}
@SuppressWarnings("unused")
public static Connection ConDATA(){
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
String url="jdbc:sqlserver://localhost:1433;DataBasename=LZT_FLOWER";
String user="sa";
String password="lll123456";
con=DriverManager.getConnection(url,user,password);
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
return con;
}
public static void release(ResultSet rs,Statement stat, Connection conn) {
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (stat != null) {
try {
stat.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
}
public static void main(String[] args) {
@SuppressWarnings("unused")
Connection conn = null;
conn=Data.ConDATA();
}
}