测试一下代码高亮功能
package lli;
import java.sql. * ;
public class mssqlconn ... {
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
// MADE by Ukinglli MSSQL 2000 数据库操作BEAN
//String sConnStr = "jdbc:microsoft:sqlserver://CHINLEE-NB:1433;DatabaseName=lli_shop,";
String url="jdbc:microsoft:sqlserver://.:1433;DatabaseName=lli_shop";
String user="sa";
String password="123123";
Connection conn = null;
ResultSet rs = null;
public mssqlconn() ...{
try ...{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) ...{
System.err.println("conn(): " + e.getMessage());
}
}
public int executeInsert(String sql)
...{
int n=0;
try
...{
conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
n=stmt.executeUpdate(sql);
}
catch(SQLException ex)
...{
System.err.println("conn.executeUpdate:"+ ex.getMessage());
}
return n;
}
public ResultSet executeQuery(String sql) ...{
rs = null;
try ...{
conn = DriverManager.getConnection(url,user,password);
Statement stmt;
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) ...{
System.err.println("conn.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeDelete(String sql)
...{
try
...{
conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex)
...{
System.err.println("conn.executeDelete: "+ ex.getMessage());
}
}
public int executeUpdate(String sql)
...{
int n=0;
try
...{
conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
n=stmt.executeUpdate(sql);
}
catch(SQLException ex)
...{
System.err.println("conn.executeDelete: "+ ex.getMessage());
}
return n;
}
public void Close()
...{
try...{
if(rs!=null)
...{
rs.close();
}
if(conn!=null)
...{
conn.close();
}
}
catch(SQLException ex)
...{
System.err.println("conn.executeDelete: "+ ex.getMessage());
}
}
}
import java.sql. * ;
public class mssqlconn ... {
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
// MADE by Ukinglli MSSQL 2000 数据库操作BEAN
//String sConnStr = "jdbc:microsoft:sqlserver://CHINLEE-NB:1433;DatabaseName=lli_shop,";
String url="jdbc:microsoft:sqlserver://.:1433;DatabaseName=lli_shop";
String user="sa";
String password="123123";
Connection conn = null;
ResultSet rs = null;
public mssqlconn() ...{
try ...{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) ...{
System.err.println("conn(): " + e.getMessage());
}
}
public int executeInsert(String sql)
...{
int n=0;
try
...{
conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
n=stmt.executeUpdate(sql);
}
catch(SQLException ex)
...{
System.err.println("conn.executeUpdate:"+ ex.getMessage());
}
return n;
}
public ResultSet executeQuery(String sql) ...{
rs = null;
try ...{
conn = DriverManager.getConnection(url,user,password);
Statement stmt;
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) ...{
System.err.println("conn.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeDelete(String sql)
...{
try
...{
conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex)
...{
System.err.println("conn.executeDelete: "+ ex.getMessage());
}
}
public int executeUpdate(String sql)
...{
int n=0;
try
...{
conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
n=stmt.executeUpdate(sql);
}
catch(SQLException ex)
...{
System.err.println("conn.executeDelete: "+ ex.getMessage());
}
return n;
}
public void Close()
...{
try...{
if(rs!=null)
...{
rs.close();
}
if(conn!=null)
...{
conn.close();
}
}
catch(SQLException ex)
...{
System.err.println("conn.executeDelete: "+ ex.getMessage());
}
}
}