<%Dim UITextCall InitUIText("EN")
Function InitUIText(ByVal LangID)
Dim cn, rs, db, sql, connstr
Set cn = Server.Createobject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.RecordSet")
'On Error Resume Next
db="DBase/DB.mdb" '数据库文件
connstr="DBQ="+Server.MapPath(""&db&"")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
sql = "SELECT * FROM UIText WHERE ID > 0 ORDER BY ID"
cn.Open connstr
rs.Open SQL, cn, 3, 3
If Not rs.EOF Then
rs.MoveLast
rs.MoveFirst
ReDim UIText(rs.RecordCount - 1)
For i = 0 To rs.RecordCount - 1
UIText(rs("ID")) = rs(LangID)
rs.MoveNext
Next
End If
cn.Close
rs.Close
Set cn = Nothing
Set rs = Nothing
'Response.Write Err.Description
End Function%>
Function InitUIText(ByVal LangID)
Dim cn, rs, db, sql, connstr
Set cn = Server.Createobject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.RecordSet")
'On Error Resume Next
db="DBase/DB.mdb" '数据库文件
connstr="DBQ="+Server.MapPath(""&db&"")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
sql = "SELECT * FROM UIText WHERE ID > 0 ORDER BY ID"
cn.Open connstr
rs.Open SQL, cn, 3, 3
If Not rs.EOF Then
rs.MoveLast
rs.MoveFirst
ReDim UIText(rs.RecordCount - 1)
For i = 0 To rs.RecordCount - 1
UIText(rs("ID")) = rs(LangID)
rs.MoveNext
Next
End If
cn.Close
rs.Close
Set cn = Nothing
Set rs = Nothing
'Response.Write Err.Description
End Function%>
UIText变量怎样才能在jsp页中也能使用呢?
<%@ page import="java.sql.*"%>
<%
string UIText="";%>
关于数据库联接这块,你去查一下相关的资料
我们一般用oracle,在websphere中联接
public class Datebase {private Connection con;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 java.sql.*;
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)
{
}
}
}
这是个添加数据的例子,其它的就改里边的sql语句就行。首先这个是get.html文件<HTML>
<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开开,输入正确的地址,回车就应该能看到结果了。
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
<HTML>
<HEAD>
<TITLE>ACCESS数据库连接</TITLE>
</HEAD>
<BODY>
<CENTER>
<FONT SIZE = 5 COLOR = blue>ACCESS数据库连接</FONT>
</CENTER>
<BR>
<HR>
<BR>
<CENTER>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
Connection con = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=db.mdb","","");
//建立数据库链接,jspdata为ODBC数据源名称
//建立Statement对象
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("SELECT * FROM UIText"); //建立ResultSet(结果集)对象,并执行SQL语句
rs.last(); //移至最后一笔
%>
<P>
USER1数据表中共有
<FONT SIZE = 4 COLOR = red>
<!--取得最后一笔记录的笔数-->
<%= rs.getRow() %>
</FONT>
笔记录
</P>
<TABLE border=1 bordercolor=#345678 bgcolor=#EFEFEF WIDTH=500>
<TR bgcolor=CCCCCC ALIGN=CENTER>
<TD><B>记录条数</B></TD><TD><B>用户编号</B></TD>
<TD><B>用户名</B></TD><TD><B>真名</B></TD>
</TR>
<%
rs.beforeFirst(); //移至第一笔记录之前
//利用while循环配合next方法将数据表中的记录列出
while(rs.next())
{
%>
<TR ALIGN=CENTER>
<!--利用getRow方法取得记录的位置-->
<TD><B><%= rs.getRow() %></B></TD>
<TD><B><%= rs.getString("userid") %></B></TD>
<TD><B><%= rs.getString("yiming") %></B></TD>
<TD><B><%= rs.getString("zhenming") %></B></TD>
</TR>
<%
}
rs.close(); //关闭ResultSet对象
stmt.close(); //关闭Statement对象
con.close(); //关闭Connection对象
%>
</TABLE>
</CENTER>
</BODY>
</HTML>