化验室工作流程:最简单的往数据库中插入数据出错...(java)

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/03 02:58:19
Q1:

看到 Class.forName();

static Class forName(String className)
Returns the Class object associated with the class or interface with the given string name.

看来forNmae返回一个Class类型对象.
可是程序中 Class.forName(drivers); 并没有看到一个接受的对象啊?

Q2:

想插入数据库一条记录可是老出错...
捕获异常 java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO ????????
数据库连接方面应该没问题,我想应该是sql语句出了问题.麻烦大家看看那里错了,应如何修改,谢谢

<%@page import="java.sql.*;" %>

<%

String drivers = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:huahua";

String exSql = "CREATE TABLE abc"+
"("+
"names varchar(10),"+
"sex varchar(10),"+
"age varchar(10),"+
"work varchar(10),"+
"marry varchar(10),"+
"address varchar(10),"+
"telephone varchar(10)"+
");";

String inSql = "INSERT into abc(names,sex,age,work,marry,address,telephone)"
+"vlaues('1','2','3','4','5','6','7');";

try
{
Class.forName(drivers);
}
catch(Exception e)
{
e.printStackTrace();
}

try
{
Connection con = DriverManager.getConnection(url);
out.print("Connection succeed<br>");

Statement smt = con.createStatement();
smt.executeUpdate(inSql);
out.print(" create a new talbe succeed");

}
catch(Exception e)
{
out.print(e);
}

%>

以上问题麻烦大家在不忙的时候解答下,谢谢~~