Java Link (JDBC) SQL database

Import java. SQL .*;
Import com. Sun. rowset. cachedrowsetimpl;
Public class dB {

Statement stmt;
String MC;
Connection conn = NULL;
Cachedrowsetimpl CRS;
String url = "JDBC: Microsoft: sqlserver: // localhost: 1433; databasename = database name ";
// Frjt_cs: name of your database
String user = "sa ";
String Password = "";
Public cachedrowsetimpl dbquery (string sqlstr) {// call this method during Query
Try
{
Class. forname ("com. Microsoft. JDBC. sqlserver. sqlserverdriver"). newinstance ();
Conn = drivermanager. getconnection (URL, user, password );
Stmt = conn. createstatement (resultset. type_scroll_sensitive, resultset. concur_updatable );
CRS = new cachedrowsetimpl ();
Resultset rs1_stmt.exe cutequery (sqlstr );
CRS. populate (RS );
If (RS! = NULL)
{
Rs. Close ();
Stmt. Close ();
Rs = NULL;
Stmt = NULL;
}
Conn. Close ();
} Catch (exception E)
{
System. Out. println ("S4:" + E. tostring ());
// E. printstacktrace ();
}
Return CRS;
}
Public void dbexe (string sqlstr) {// used to add, delete, and modify
Try
{
Class. forname ("com. Microsoft. JDBC. sqlserver. sqlserverdriver"). newinstance ();
Conn = drivermanager. getconnection (URL, user, password );
Stmt = conn. createstatement (resultset. type_scroll_sensitive, resultset. concur_updatable );
// System. Out. println ("-------------- ggggrr -----------" + sqlstr );
Stmt.exe cute (sqlstr );
Stmt. Close ();
Conn. Close ();
}
Catch (exception E)
{
System. Out. println (E. tostring ());
}
}
}