62,612
社区成员
发帖
与我相关
我的任务
分享
Java codeimport java.sql.*;
public class testJDBC01
{
public static void main(String[] args)
{
Connection conn = null;
Statement stmt = null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
conn = DriverManager.getConnection(url,"sa","sa");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//新增表,以及插入数据
// String sql1 = "create table d_student (sno int primary key,sname varchar(50),age int)";
// stmt.executeUpdate(sql1);
//
// String insertSql1 = "insert into d_student values(1,'zhangsan',20)";
// int count1 = stmt.executeUpdate(insertSql1);
// insertSql1 = "insert into d_student values(2,'wangwu',20)";
// count1 = stmt.executeUpdate(insertSql1);
// insertSql1 = "insert into d_student values(3,'lisi',20)";
// count1 = stmt.executeUpdate(insertSql1);
//新增表
String sql2 = "create table d_course (cno int primary key,cname varchar(50),credit int )";
stmt.executeUpdate(sql2);
//加列属性
String insertSql2 = "insert into d_course values(1,'语文',5)";
int count2 = stmt.executeUpdate(insertSql2);
insertSql2 = "insert into d_course values(2,'数学',6)";
count2 = stmt.executeUpdate(insertSql2);
insertSql2 = "insert into d_course values(3,'英语',7)";
count2 = stmt.executeUpdate(insertSql2);
//新增表
String sql3 = "create table d_sc (sno int ,cno int primary key (sno,cno) , score int )";
stmt.executeUpdate(sql3);
//加列属性
String insertSql3 = "insert into d_course values(1,1,80)";
int count3 = stmt.executeUpdate(insertSql3);
insertSql3 = "insert into d_course values(2,2,90)";
count3 = stmt.executeUpdate(insertSql3);
insertSql3 = "insert into d_course values(3,3,100)";
count3 = stmt.executeUpdate(insertSql3);
//查询数据
// String sql = "select * from d_student";
// ResultSet rs = stmt.executeQuery(sql);
// //int counter=0;
// rs.last();
// System.out.println("记录数="+rs.getRow());
// rs.beforeFirst();
// while(rs.next())
// {
// System.out.println(rs.getString("sname"));
// //counter++;
// }
// //System.out.println("记录数="+counter);
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
try
{
stmt.close();
conn.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
}
Connection con=null;
String url="jdbc:odbc:student";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();