/* *完成选课功能的函数 */ public void selectClass(String xh,String kcbh,String jsbh) {//选课 Connection con = null ; Statement sm = null; ResultSet rs = null; try{
con = DBConnection.getAdministratorConnection(); sm = con.createStatement(); rs = sm.executeQuery("SELECT * FROM sk WHERE kcbh ='" + kcbh + "' and jsbh ='" + jsbh+"'");//sql语句,select 功能,返回相应的查询结果
if(rs.next() == true) {//处理上面sql语句返回的查询结果 //System.out.println(xh);System.out.println(kcbh);System.out.println(jsbh); String str="INSERT INTO xk(xh,kcbh,jsbh) VALUES(?,?,?)"; PreparedStatement ps=con.prepareStatement(str); ps.setString(1,xh); ps.setString(2,kcbh); ps.setString(3,jsbh); int i=ps.executeUpdate(); if(i==1 ) JOptionPane.showMessageDialog(null,"选课成功","提示信息",JOptionPane.INFORMATION_MESSAGE); } //else throw new Exception();
public Datebase(int i) throws Exception{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=d:/6848搜索程序/data/webdata.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(strurl);
}
/**
* 执行插入操作
*/
public boolean insert(String strSql) throws Exception{
PreparedStatement psmt = con.prepareStatement(strSql);
psmt.executeUpdate();
return true;
}
/**
* 执行更新和删除操作
*/
public boolean update(String sql)throws Exception{
PreparedStatement psmt=con.prepareStatement(sql);
psmt.executeUpdate();
return true;
}
/**
* 执行select
*/
public ResultSet select(String sql)throws Exception{
PreparedStatement psmt=con.prepareStatement(sql);
return psmt.executeQuery();
}
public void close_con()throws Exception{
con.close();
}
}
import sun.jdbc.odbc.JdbcOdbcDriver;
import javax.swing.*;public class DBConnection
{
static
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null, "无法初始化sun.jdbc.odbc.JdbcOdbcDriver, 系统将关闭", "致命错误", JOptionPane.ERROR_MESSAGE);
System.exit(0);
}
}
public static Connection getAdministratorConnection()
throws SQLException
{
String url = "jdbc:odbc:Driver={SQL Server};" +
"Server=10.1.111.210;uid=superstudent254;" +
"pwd=student254z;Database=Student254";
return DriverManager.getConnection(url);
}
public static Connection getTeacherConnection()
throws SQLException
{
String url = "jdbc:odbc:Driver={SQL Server};" +
"Server=10.1.111.210;uid=highstudent254;" +
"pwd=student254y;Database=Student254";
return DriverManager.getConnection(url);
}
public static Connection getStudentConnection()
throws SQLException
{
String url = "jdbc:odbc:Driver={SQL Server};" +
"Server=10.1.111.210;uid=superstudent254;" +
"pwd=student254z;Database=Student254";// return DriverManager.getConnection(url);
}
public static void main(String[] args)
{
try
{
getAdministratorConnection();
System.out.println("dfa");
}
catch(Exception ex)
{
}
}
}//连接数据库,以Sql2000为例
*完成选课功能的函数
*/
public void selectClass(String xh,String kcbh,String jsbh) {//选课
Connection con = null ;
Statement sm = null;
ResultSet rs = null;
try{
con = DBConnection.getAdministratorConnection();
sm = con.createStatement();
rs = sm.executeQuery("SELECT * FROM sk WHERE kcbh ='" + kcbh + "' and jsbh ='" + jsbh+"'");//sql语句,select 功能,返回相应的查询结果
if(rs.next() == true) {//处理上面sql语句返回的查询结果
//System.out.println(xh);System.out.println(kcbh);System.out.println(jsbh);
String str="INSERT INTO xk(xh,kcbh,jsbh) VALUES(?,?,?)";
PreparedStatement ps=con.prepareStatement(str);
ps.setString(1,xh);
ps.setString(2,kcbh);
ps.setString(3,jsbh);
int i=ps.executeUpdate();
if(i==1 )
JOptionPane.showMessageDialog(null,"选课成功","提示信息",JOptionPane.INFORMATION_MESSAGE);
}
//else throw new Exception();
}
catch(SQLException e){
JOptionPane.showMessageDialog(null,"选课失败,已选相同课程","结果",JOptionPane.ERROR_MESSAGE);
e.printStackTrace();
//return false;
}
catch (Exception e) {
e.printStackTrace();
JOptionPane.showMessageDialog(null,"选课错误","错误信息",JOptionPane.WARNING_MESSAGE);
}finally{
try
{
rs.close();
con.close();
}
catch(Exception ex)
{
}
}
}
<BODY><FORM METHOD=POST ACTION="get.jsp">What's your name? <INPUT TYPE=TEXT NAME=username SIZE=20><BR>What's your e-mail address? <INPUT TYPE=TEXT NAME=email SIZE=20><BR>What's your age? <INPUT TYPE=TEXT NAME=age SIZE=4><P><INPUT TYPE=SUBMIT value="submit"></FORM>
</BODY>
</HTML>
这个是get.jsp文件,把它和get.html放在一个文件夹里.<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>get</title>
</head><body>
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection con = DriverManager.getConnection("jdbc:odbc:get");//get是Access的名字,get.mdb
//Creating the Connection StatementStatement stmt = con.createStatement();// Create a statement object for use over the connectionString username=request.getParameter("username");String email=request.getParameter("email");String age=request.getParameter("age");stmt.executeUpdate("INSERT INTO yan (username,email,age ) " + "VALUES('"+username+"','"+email+"','"+age+"')");//yan是数据库里表的名字ResultSet rs=stmt.executeQuery("SELECT username,email,age FROM yan");while(rs.next())
{
%>name: <%= rs.getString(1) %> <p>
email: <%= rs.getString(2) %><p>
age: <%= rs.getString(3) %><%
}// Cleanup resourcesrs.close();
stmt.close();
con.close();
%>
</body>
</html>
数据库的连接如果你会的话,把access设置好,然后把tomcat开开,输入正确的地址,回车就应该能看到结果了。
tomcat 我的机器装了他就可以运行了是吧 :) 谢谢各位 问题解决就结账