Software 151 links to Wang Tao database

Package Com.cqvie;

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

public class Test {

Constant definition (general all caps) localhost
public static final String dbdriver= "Net.sourceforge.jtds.jdbc.Driver";
public static final String dburl= "jdbc:jtds:sqlserver://127.0.0.1 (native access): 1433;databasename=wangchengyan"; School default Port
public static final String user= "Wang";
public static final String password= "123";
public static void Main (string[] args) throws Exception {
Try
{
Class.forName (dbdriver);//Load driver (uppercase is constant, value is unchanged)

Connection cn=drivermanager.getconnection (Dburl);//Connection
Statement st=cn.createstatement ();//execute command
St.executeupdate ("INSERT into Student values (' 1123 ', ' Lily ', ' female ', ' 1996-11-06 ', ' Software ')");
Cn.close ();
}
catch (Exception ex) {ex.printstacktrace ();}
}
}

Software 151 links to Wang Tao database