（在线等）javabean 连接数据库问题

显示全部楼层 · 2008-12-30 12:40:24

package bean;
import java.sql.*;
public class link{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:DB";
String user="";
String pwd="";
Connection con = DriverManager.getConnection(url,user, pwd);
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String name=request.getParameter("name");
String password=request.getParameter("password");
String sql="insert into student(name,password)values('"+name+"','"+password+"')";
stmt.executeUpdate(sql);
}
编译出错：link.java:4:需要
Class.forName("sun.jabc.odbc.JdbcOsbcDriver");
link.java:14:需要
stmt.executeUpdate;

千问 · 2008-12-30 12:40:24

连接MSSQL2005数据库import java.sql.*;public class Test {public static void main(String[] srg) {String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//加载JDBC驱动String dbURL = "jdbc:sqlserver://localhost:1459; DatabaseName=test";//连接服务器和数据库testString userName = "sa";//默认用户名String userP...