jsp与sql server相连,Tomcat总提示如下错误: 這個是ODBC提示的錯誤信息你是用JDBC﹕ODBC橋接的吧那就是ODBC沒設置對﹐或是SQL SERVER設置有問題另外最大的一個原因是你的用戶沒有傳過去你檢查一下連接的地方﹐用戶和口令是否OK 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我是刚刚开始学习jsp,我原来用asp,在asp中:db.open "provider=sqloledb;database=talkings;uid=sa;pwd=;data source=yanfa0"同样用jsp如何实现???? jsp和asp数据库连接过程完全不一样。你那连接过程根本不可能通过的。自己到网上找找相关文章吧。很多的。 有没有搞错,我是很弱,但没有你说的那样!!!看看,你能不能解决???<talkings.java>package talkings;import java.sql.*;import java.io.*;import java.util.*;public class talkings { String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String sConnStr = "jdbc:odbc:talkings"; Connection connect = null; ResultSet rs = null; String FileName = "F:\\user.log"; Vector planets =null; BufferedReader buff = null; BufferedWriter pw = null; public talkings() { try { Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e) { System.err.println( e.getMessage()); } } public ResultSet executeQuery(String sql) { try { connect = DriverManager.getConnection(sConnStr,"sa",""); Statement stmt = connect.createStatement(); rs = stmt.executeQuery(sql); } catch(SQLException ex) { System.err.println(ex.getMessage()); } return rs; } public int executeUpdate(String sql) { int result = 0; try { connect = DriverManager.getConnection(sConnStr,"sa",""); Statement stmt = connect.createStatement(); result = stmt.executeUpdate(sql); } catch(SQLException ex) { System.err.println(ex.getMessage()); } return result; } public void userLog(String work) { // 建立一文件操作对象 File f = new File(FileName); String work1 = work; if(!f.exists()) { // 如果文件不存在, 创建新文件 try { pw = new BufferedWriter(new FileWriter(FileName)); pw.write("用户日志文件 :"); // 初始化 pw.close(); }catch(IOException e) {} } try { planets = new Vector(); //利用Vector保存日志中原有的东西 buff = new BufferedReader(new FileReader(FileName)); //读文件中的数据 String his = buff.readLine(); while(his!=null) { planets.addElement(his); //将原有日志加入Vector his = buff.readLine(); } planets.addElement(work1); pw = new BufferedWriter(new FileWriter(FileName)); //向文件中写数据 Enumeration enum = planets.elements(); String now =""; while(enum.hasMoreElements()) //遍历Vector里的数据 { now=(String)enum.nextElement(); pw.write(now); pw.newLine(); } buff.close(); pw.close(); }catch(IOException e) {} }}<user_info_save.jsp><%@page import="java.sql.*" import="java.lang.String"%><jsp:useBean id="connDbBean" scope="page" class="talkings.talkings"/><%request.setCharacterEncoding("GB2312");%><%String user_name = request.getParameter("user_name");String password = request.getParameter("password");String real_name = request.getParameter("real_name");String sex = request.getParameter("sex");String born_year = request.getParameter("born_year");String born_month = request.getParameter("born_month");String born_day = request.getParameter("born_day");String born_date = born_year + "-" + born_month + "-" +born_day;String marry = request.getParameter("marry");String rela_tele = request.getParameter("rela_tele");String mobile_phone = request.getParameter("mobil_phone");String email = request.getParameter("email");String home_page = request.getParameter("home_page");String rela_addr = request.getParameter("rela_addr");String hobby = request.getParameter("hobby");String user_intr = request.getParameter("user_intr");//数据库连接String sql;sql = "insert into user_info" + "(";sql += "user_name,password,real_name,sex,born_date,marry,rela_tele,mobile_phone";sql += "," + "email,home_page,rela_addr,hobby,user_intr" + ")";sql += " " + "values" + "(" + "'"+user_name+"','"+password+"','"+real_name+"','"+sex+"','"+born_date+"'";sql += "," + "'"+marry+"','"+rela_tele+"','"+mobile_phone+"','"+email+"','"+home_page+"'";sql += "," + "'"+rela_addr+"','"+hobby+"','"+user_intr+"'" + ")";connDbBean.executeUpdate(sql);%><jsp:forward page = "register_success.html"/>odbc源连接也完全正确。不要怀疑!!!重要的是我的sql server是客户端。data source="yanfa0" 在设置odbc时候设置默认数据库了没?还有要设置正确的的帐户和密码。连接完了之后可以通过odbc测试一下连接看看是否连接成功。 求jsp增删改查实例最好详细点!! 数据批量删除问题 WEB-INF目录是否必须的? 求如何获取客户端所在的地理信息? html不能调用jsp???? jsp出现数据混乱? 用java开发web程序如何快速部署,还有什么版本控制软件最好? 如何获得当前页面的URL? 1.怎样在页面上实现象excel一样的表格交互。2怎样把此表格入库??? session是個好東西. linux下java连接mysql的常见的关键错误之一 Unable to compile class for JSPimport com.jspsmart.upload.*;
同样用jsp如何实现????
你那连接过程根本不可能通过的。
自己到网上找找相关文章吧。
很多的。
看看,你能不能解决???
<talkings.java>package talkings;import java.sql.*;
import java.io.*;
import java.util.*;public class talkings {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:talkings";
Connection connect = null;
ResultSet rs = null;
String FileName = "F:\\user.log";
Vector planets =null;
BufferedReader buff = null;
BufferedWriter pw = null; public talkings() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
try {
connect = DriverManager.getConnection(sConnStr,"sa","");
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql) {
int result = 0;
try {
connect = DriverManager.getConnection(sConnStr,"sa","");
Statement stmt = connect.createStatement();
result = stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return result;
} public void userLog(String work) {
// 建立一文件操作对象
File f = new File(FileName);
String work1 = work;
if(!f.exists()) { // 如果文件不存在, 创建新文件
try {
pw = new BufferedWriter(new FileWriter(FileName));
pw.write("用户日志文件 :"); // 初始化
pw.close();
}catch(IOException e) {}
}
try {
planets = new Vector(); //利用Vector保存日志中原有的东西
buff = new BufferedReader(new FileReader(FileName)); //读文件中的数据
String his = buff.readLine();
while(his!=null)
{
planets.addElement(his); //将原有日志加入Vector
his = buff.readLine();
}
planets.addElement(work1);
pw = new BufferedWriter(new FileWriter(FileName)); //向文件中写数据
Enumeration enum = planets.elements();
String now ="";
while(enum.hasMoreElements()) //遍历Vector里的数据
{
now=(String)enum.nextElement();
pw.write(now);
pw.newLine();
}
buff.close();
pw.close();
}catch(IOException e) {}
}
}<user_info_save.jsp><%@page import="java.sql.*" import="java.lang.String"%>
<jsp:useBean id="connDbBean" scope="page" class="talkings.talkings"/>
<%request.setCharacterEncoding("GB2312");%>
<%
String user_name = request.getParameter("user_name");
String password = request.getParameter("password");
String real_name = request.getParameter("real_name");
String sex = request.getParameter("sex");
String born_year = request.getParameter("born_year");
String born_month = request.getParameter("born_month");
String born_day = request.getParameter("born_day");
String born_date = born_year + "-" + born_month + "-" +born_day;
String marry = request.getParameter("marry");
String rela_tele = request.getParameter("rela_tele");
String mobile_phone = request.getParameter("mobil_phone");
String email = request.getParameter("email");
String home_page = request.getParameter("home_page");
String rela_addr = request.getParameter("rela_addr");
String hobby = request.getParameter("hobby");
String user_intr = request.getParameter("user_intr");
//数据库连接
String sql;
sql = "insert into user_info" + "(";
sql += "user_name,password,real_name,sex,born_date,marry,rela_tele,mobile_phone";
sql += "," + "email,home_page,rela_addr,hobby,user_intr" + ")";
sql += " " + "values" + "(" + "'"+user_name+"','"+password+"','"+real_name+"','"+sex+"','"+born_date+"'";
sql += "," + "'"+marry+"','"+rela_tele+"','"+mobile_phone+"','"+email+"','"+home_page+"'";
sql += "," + "'"+rela_addr+"','"+hobby+"','"+user_intr+"'" + ")";
connDbBean.executeUpdate(sql);
%>
<jsp:forward page = "register_success.html"/>odbc源连接也完全正确。不要怀疑!!!
重要的是我的sql server是客户端。data source="yanfa0"
设置默认数据库了没?
还有要设置正确的的帐户和密码。
连接完了之后可以通过odbc测试一下连接看看是否连接成功。