请问有jsp连接access数据库的项目或网站吗?本人急需,请发给我ok 邮箱:[email protected]
解决方案 »
- struts2怎样实现多文件上传
- jsp时间转换问题
- JSP处理下拉列表组件
- 使子窗口的数据提交到父窗口
- 做过session持久化的请进来,求教!
- "Host '127.0.0.1' is not allowed to connect to this MySQL server"
- 求大神指教hibernate,一对多,多对一的作用
- Jbuilder9中使用Context连接Oracle数据库的问题:总提示Context path is already in use
- 关于Servlet的小问题,在线等待,马上给分!
- 急!急!100分问题求解(不够可加)输入中文到oracle数据库乱码的问题
- 在线数学公式的编辑器怎么实现,找了很多网上资料还是有些模糊,如果能帮实一功能实现我会重谢的。
- jsp+dao简单的增删查功能已经实现修改功能报java.sql.Date和java.util.Date转换异常
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class ConnectAccess { private Connection conn = null;
private String password = "";
private String db_path = "D://#####Wygkcnsdfds6565659093dfd#####.mdb";
private Connection getConnection() {
String dburl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};" +
"pwd="+password+";DBQ="+db_path;
if (conn == null) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(dburl); } catch (Exception e) {
e.printStackTrace();
}
}
return conn;
} public ResultSet execQuery(String sql) {
ResultSet rs = null;
conn = this.getConnection();
try {
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
} return rs;
} private void showResult(ResultSet rs) {
try {
while (rs.next()) {
System.out.println("username:" + rs.getString("username"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
} private void closeConnection() {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
} public static void main(String[] args){
String sql = "select UserName from Wygkcn_Admin where id = 1";
ConnectAccess ca = new ConnectAccess();
ResultSet rs = ca.execQuery(sql);
ca.showResult(rs);
ca.closeConnection(); }
}
<%@ page language="java" pageEncoding="utf-8" %>
<html>
<body bgcolor="pink">
<form action="check.jsp" method="post" name=myform>
<div align="center"><strong><font size="6">用户登录</font></strong>
</div>
<table width="300" align="center">
<tr>
<td align="center">用户名:</td>
<td align="center"><input type="text" name="name"></td>
</tr>
<tr>
<td align="center">密码:</td>
<td align="center"><input type="password" name="password"></td>
</tr>
</table>
<br> <div align="center"> <input type="submit" name="bu1" value="登录" >
<input type="reset" name="bu2" value="重置">
<a href="register.jsp">注册</a>
</div>
</form>
</body>
</html>
检查页面,这个其实应该放在servlet里
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<html>
<body>
<% request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
String name=request.getParameter("name");
String password=request.getParameter("password");
String sql="";
boolean flag=false;
Connection con;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ e.printStackTrace();
}
String url="jdbc:odbc:information";
try{
con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
sql="select * from user";
ResultSet rs=stmt.executeQuery(sql);
while (rs.next())
{ if(name.equalsIgnoreCase(rs.getString(1))
&&password.equalsIgnoreCase(rs.getString(2)))
flag=true;
}
rs.close();
stmt.close();
con.close();
}
catch(SQLException e)
{ e.printStackTrace();
}
if(flag==true)
response.sendRedirect("welcome.jsp");
else
out.print("您还没有注册<br>");
out.print("<a href="+"register.jsp"+">注册</a>");
%>
</body>
</html>