-- 作者：misdjava
-- 发布时间：4/22/2007 8:44:00 AM
-- 求助javabean问题
我写了一个javabean数据库驱动与jsp页面连接!!
怎么老是不行,看看高手们这是什么问题?我觉得最大问题是出在modify_confirm.jsp,小弟是初学者.就是搞不明白.怎么也插入数据不成功!!!!但编译不会出错.
提示是:mydb():com.microsoft.jdbc.sqlserver.SQLServerDriver
aq.executeQuery:No suitable driver 第一个javabean
mydb.java --------------------------------------------- mydb.java
package com;
import java.sql.*;
import java.io.*;
public class mydb {
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tusy";
private Connection conn=null;
private Statement stmt=null;
ResultSet rs=null;
public mydb()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("mydb():"+e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
rs=null;
try
{
conn=DriverManager.getConnection(sConnStr,"sa","sa");
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex )
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql)
{
stmt=null;
rs=null;
try
{
conn=DriverManager.getConnection(sConnStr,"sa","sa");
stmt= conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex )
{
System.err.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.printStackTrace();
}
}
/* public static void main(String args[])
{
System.out.println("编译成功!!");
}*/
} --------------------------------------
add.jsp
-------------------------
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="modify_confirm.jsp">
<table width="241" border="0">
<tr>
<td width="67">姓名:</td>
<td colspan="2"><label>
<input name="name" type="text" id="name" size="20" />
</label></td>
</tr>
<tr>
<td>性别:</td>
<td colspan="2"><label>
<input name="sex" type="text" id="sex" size="20" />
</label></td>
</tr>
<tr>
<td>备注:</td>
<td colspan="2"><label>
<input name="text" type="text" id="text" size="20" />
</label></td>
</tr>
<tr>
<td> </td>
<td width="59"><label>
<input type="submit" name="Submit" value="添加" />
</label></td>
<td width="101"><label>
<input type="reset" name="Submit2" value="重置" />
</label></td>
</tr>
</table>
</form>
</body>
</html>
---------------------------------------------------
modify_confirm.jsp
------------------------------------------------------- <%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="ado" scope="request" class="com.mydb" />
<%
String name =request.getParameter("name");
String sex=request.getParameter("sex");
String text=request.getParameter("text");
String sql=null;
ado.executeUpdate(sql);
sql="insert into test values('"+name+"','"+sex+"','"+text+"')";
%>
</body>
</html>
|