JDBC-ODBC 连接怎么不成功呢?
来源:百度知道 编辑:UC知道 时间:2024/05/21 16:53:50
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=GB2312" %>
<%
String user = "wangyu";
String passwd = "123";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:First";
try
{
Class.forName(driver);
}
catch(Exception e)
{
e.printStackTrace();
}
try
{
Connection con = DriverManager.getConnection(url,user,passwd);
out.print("连接成功。");
Statement smt = con.createStatement();
String quary = "CREATE TABLE abc"+
"("+
"names varchar(10),"+
"phone varchar(10) "+
");";
smt.executeQuery(quary);
smt.close();
con.close();
}
catch(SQLException e)
{
e.pri
<%@ page contentType="text/html;charset=GB2312" %>
<%
String user = "wangyu";
String passwd = "123";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:First";
try
{
Class.forName(driver);
}
catch(Exception e)
{
e.printStackTrace();
}
try
{
Connection con = DriverManager.getConnection(url,user,passwd);
out.print("连接成功。");
Statement smt = con.createStatement();
String quary = "CREATE TABLE abc"+
"("+
"names varchar(10),"+
"phone varchar(10) "+
");";
smt.executeQuery(quary);
smt.close();
con.close();
}
catch(SQLException e)
{
e.pri
把你的con.createStatement()改为
con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE)
再把 smt.executeQuery(quary)
改为 smt.executeUpdate(quary)
再试试行不行,默认的createStatement是只读的,而且只能相前移
如果要进行更新或删除操作的话应该用
smt.executeUpdate(sql语句)