manipulating databases with statement

I

Import java.sql.Connection;
Import Java.sql.DriverManager;
Import Java.sql.ResultSet;
Import java.sql.Statement;

public class Testdemo {
public static final String dbdriver= "Net.sourceforge.jtds.jdbc.Driver";
public static final String Dburl
= "Jdbc:jtds:sqlserver://127.0.0.1:1433;databasename=pengmengyue";
public static final String dbuser= "sa";
public static final String password= "123";

public static void Main (string[] args) throws Exception {
Connection Conn=null;
Statement Stmt=null;
Class.forName (Dbdriver);
Conn=drivermanager.getconnection (Dburl);
Stmt=conn.createstatement ();
String sql= "Select Sno,cno,grade from Grade";
ResultSet rs=stmt.executequery (SQL);
while (Rs.next ()) {
String sno=rs.getstring ("Sno");
String cno=rs.getstring ("CNO");
int Grade=rs.getint ("Grade");
System.out.println ("Study No.:" +sno+ "Course Number:" +cno+ "score:" +grade ");
}
Rs.close ();
Stmt.close ();
Conn.close ();
}

}

manipulating databases with statement