UC知道java与数据库的连接的问题
来源：百度知道 编辑：UC知道 时间：2024/06/23 09:09:29
import java.sql.*;
public class Jtest
{
public void createTable(String tableName) //在数据库javaData中建表tableName
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection("jdbc:odbc:javaData","sa","abc");
Statement s=c.createStatement();
s.executeUpdate(
"create table "+tableName+"(Sno integer,Sname char(40))");
s.executeUpdate(
"insert into "+tableName+" values (1006,'大海')");
s.executeUpdate(
"insert into "+tableName+" values (1001,'天公')");
s.executeUpdate(
"insert into "+tableName+" values (007,'伟哥')");
s.close();
c.close();
System.out.println("建表成功!");
}
catch(Exception e)
{
e.printStackTrace();
}
public class Jtest
{
public void createTable(String tableName) //在数据库javaData中建表tableName
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection("jdbc:odbc:javaData","sa","abc");
Statement s=c.createStatement();
s.executeUpdate(
"create table "+tableName+"(Sno integer,Sname char(40))");
s.executeUpdate(
"insert into "+tableName+" values (1006,'大海')");
s.executeUpdate(
"insert into "+tableName+" values (1001,'天公')");
s.executeUpdate(
"insert into "+tableName+" values (007,'伟哥')");
s.close();
c.close();
System.out.println("建表成功!");
}
catch(Exception e)
{
e.printStackTrace();
}
表名无效，说明你开始那段见表的代码没有成功，原因就是你没commit
commit
别用数据源了
用url请求
改为手动提交
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection("jdbc:odbc:javaData","sa","abc");
boolean autocommit = c.getAutoCommit();
Statement s=c.createStatement();
s.executeUpdate(
"create table "+tableName+"(Sno integer,Sname char(40))");
s.executeUpdate(
"insert into "+tableName+" values (1006,'大海')");
s.executeUpdate(
"insert into "+tableName+" values (1001,'天公')");
s.executeUpdate(
"insert into "+tableName+" values (007,'伟哥')");
c.commit();
c.setAutoCommit(autoCommit);
那你就在javaData中在建一边表呗。。
要不就改
Connection c=DriverManager.getConnection("jdbc:odbc:master&qu