放分了~~~~~~~~

try {
            Conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://crm:1433;crm,"user","kkk");
Stmt=Conn.createStatement();
        }
        catch (ClassNotFoundException e) {
            System.out.println("mydb(): " + e.getMessage());
        }
        catch (SQLException e2) {
            System.out.println("SQLException: " + e2.getMessage());
        }
}

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://crm:1433;crm,"user","kkk");
            Stmt=Conn.createStatement();
        }
        catch (ClassNotFoundException e) {
            System.out.println("mydb(): " + e.getMessage());
        }
        catch (SQLException e2) {
            System.out.println("SQLException: " + e2.getMessage());
        }
}
("jdbc:microsoft:sqlserver://crm:1433;crm,"user","kkk");这些东西都是什么意思？我要是不需要用户名和密码怎么写？
你要是再页面上就这样吧~没反应就连上了~~有错误题试就每连上~简单吧~
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://crm:1433;crm,"user","kkk");
Stmt=Conn.createStatement();
ResultSet rs=stmt.executeQuery("select 1");
//"select 1":我用的是mysql，你换个SQL Server的语句在这里就行了~但是要是正确的哦
while(rs.next()){}
我要是不需要用户名和密码怎么写？
da:("jdbc:microsoft:sqlserver://crm:1433;crm）
("jdbc:microsoft:sqlserver://crm:1433;crm,"user","kkk");这些东西都是什么意思？我要是不需要用户名和密码怎么写？
("jdbc:microsoft:sqlserver://crm:1433;crm,"","");
sqlserver：你的机器名或ip：3306     crm你的数据库名   没用户密码就用""
try{
    Conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://crm:1433;crm,"user","kkk");
Stmt=Conn.createStatement();
}catch(Exception e){
%>
<SCRIPT LANGUAGE=JavaScript>
window.alert("与数据库连接出错！");
window.history.back();
</SCRIPT><%
}finally{
                  Rst.close();
Stmt.close();
                  Conn.close();
%>SCRIPT Language="JavaScript">
window.alert("连接数据库成功！");
window.location.href="welcome.jsp";
</SCRIPT><%
};
我怎么感觉有错误/crm/add1.jsp:4: cannot resolve symbol
symbol  : method Parameter (java.lang.String)
location: interface javax.servlet.http.HttpServletRequest
      String company_date=request.Parameter("company_date");
                                 ^
/crm/add1.jsp:6: cannot resolve symbol
symbol  : method Parameter (java.lang.String)
location: interface javax.servlet.http.HttpServletRequest
      String company_owner=request.Parameter("company_owner");
                                  ^
/crm/add1.jsp:8: cannot resolve symbol
symbol  : method Parameter (java.lang.String)
location: interface javax.servlet.http.HttpServletRequest
      String company_name=request.Parameter("company_name");错误题是在上面　　什么意思　　谁能告诉我？？
这个错误怎么解决？？/crm/data.jsp:15: cannot resolve symbol
symbol  : class Resultset
location: package sql
      java.sql.Resultset Rst;
jdbc驱动，不好吧，这样不是把数据库逻辑层直接暴露给web端了，建议用连接池，
你有问题就提到这里~大家会解决的~~我们不能用qq~^_^~
你的错误：
String company_date=（String)request.Parameter("company_date");
页面加上<%@ page import="java.util.*" import="java.sql.*" %>
看看错误会不回少一些~~~你把程序贴出来~~让大家看给你看看呗~
程序代码如下
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<% Class.forName("com.microsoft.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=crm";
String user="";
String password="";
//Á¬½Ó¶ÔÏó
java.sql.Connection Conn;
//Óï¾ä¶ÔÏó
java.sql.Statement Stmt;
//½á¹û¼¶¶ÔÏó
java.sql.Resultset Rst;//¼ÓÔØÇý¶¯³ÌÐò
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
try{
Conn=DriverManager.getConnection("url","user","password");
Stmt=Conn.createStatement;
}
catch(Exception e)
{
out.println("ÎÞ·¨Á¬½ÓÊý¾Ý¿â");
}
%>
我已经下载了 msbase.jar mssqlserver.jar  msutil.jsr  并且复制到了resin的bin下面
错误如下
/crm/data.jsp:22: cannot resolve symbol
symbol  : class Resultset
location: package sql
      java.sql.Resultset Rst;
              ^
/crm/data.jsp:34: cannot resolve symbol
symbol  : variable createStatement
location: interface java.sql.Connection
       Stmt=Conn.createStatement;
还有下面的错误
/crm/add1.jsp:4: cannot resolve symbol
symbol  : method Parameter (java.lang.String)
location: interface javax.servlet.http.HttpServletRequest
      String company_date=request.Parameter("company_date");
                                 ^
/crm/add1.jsp:6: cannot resolve symbol
symbol  : method Parameter (java.lang.String)
location: interface javax.servlet.http.HttpServletRequest
      String company_owner=request.Parameter("company_owner");
String company_date=request.getParameter("company_date");
package test;
import java.sql.*;
import java.util.*;
public class DBConnect
{
private String sdbDriver="sun.jdbc.odbc.JdbcOdbcDriver";//jdbc-odbc驱动程序
private String sdbUrl="jdbc:odbc:company";
private String sdbUsername="sa";
private String sdbPassword="admin";
public Statement stmt;
public rs=null;
public DBConnec()throws ClassNotFoundException,SQLException{
try{
Class.forName(sdbDrvier);//加载jdbc-odbc驱动程序
conn=DriverManagerConnection(sdbUrl,sdbUsername,sdbPassword);

}catch(Exception e){
System.out.println("Excepion occur.Message is":+e.getMessage());
}
}
public ResultSet executeQuery(String SQL){//执行sql语句
rs=null;
try{
stmt=conn.createStatement();
rs=stmt.executeQuey(SQL);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
System.out.println("aq.executeQuery:"+SQL);
}
return rs;
}
public void executeUpdate(String sql){
stmt=null;
rs=null;
try{
conn=DriverManager.getConnection(sdbUrl,sdbUsername,sdbPassword);
stmt=conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}catch(SQLException ex){
System.out.println("aq.executeQuery:"+ex.getMessage());
}
}

public void closeStmt(){
try{stmt.close();}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();}
catch(SQLException e){
e.println();}
}

}
我的是通的！给你参考一下！！
("jdbc:microsoft:sqlserver://crm:1433;crm,"user","kkk");这些东西都是什么意思？我要是不需要用户名和密码:
("jdbc:microsoft:sqlserver://crm:1433;crm,"","");
package riso.mybook.jsp.c7;import java.sql.*;public class DBConn{

private String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
private String DBLocation="jdbc:odbc:basiclyb";
private String DBUser="sa";
private String DBPwd="";
private Connection conn=null;

public DBConn(){
}

public DBConn(String DBDriver,String DBLocation){
this.DBDriver=DBDriver;
this.DBLocation=DBLocation;
}

public void setDBLocation(String DBLocation){
this.DBLocation=DBLocation;
}

public void setDBDriver(String DBDriver){
this.DBDriver=DBDriver;
}

public void setDBUser(String DBUser){
this.DBUser=DBUser;
}

public void setDBPwd(String DBPwd){
this.DBPwd=DBPwd;
}

public void connect(){
try{
Class.forName(DBDriver);
conn=DriverManager.getConnection(DBLocation,DBUser,DBPwd);
}catch(ClassNotFoundException e){
}catch(SQLException e){
}
}

public Connection getConnection(){
if (conn==null){
connect();
}
return conn;
}
}
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=crm";
String user="";
String password="";
//Á¬½Ó¶ÔÏó
java.sql.Connection Conn;
//Óï¾ä¶ÔÏó
java.sql.Statement Stmt;
//½á¹û¼¶¶ÔÏó
//java.sql.Resultset Rst;//¼ÓÔØÇý¶¯³ÌÐòtry{
/*无错运行，否则连接错*/
Class.forName("org.gjt.mm.mysql.Driver");
Conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433/crm?user='"+user+"'&password='"+password+"'");
Stmt=Conn.createStatement();

/*下面几行，也可以用，但是要加上
import com.sqlserver.jdbc.jdbc2.optional.SqlDataSource; 这句的里的英文不对，去你加的jar里找*/
//SqlDataSource ds = new SqlDataSource();//SqlDataSourc这个类型不对，去你加的jar里找
//ds.setServerName(serverName);
//ds.setPort(port);
//ds.setDatabaseName(dataBaseName);
    //Conn = ds.getConnection(loginName, passWord);
    //Stmt=Conn.createStatement();
}
catch(Exception e)
{
out.println("error")
你的java.sql.Resultset应该改为java.sql.ResultSet;
request.Parameter改成request.getParameter();
还剩下 22 个错误  就是这个错误
/crm/add1.jsp:4: cannot resolve symbol
symbol  : method Parameter (java.lang.String)
location: interface javax.servlet.http.HttpServletRequest
      String company_date=request.Parameter("company_date");
                                 ^
/crm/add1.jsp:6: cannot resolve symbol
symbol  : method Parameter (java.lang.String)
location: interface javax.servlet.http.HttpServletRequest
      String company_owner=request.Parameter("company_owner");22个都是这样的错误
String company_owner=(String)request.getParameter("company_owner");