我用jsp做了一个注册页面,调用java类的方法,怎么没有用,急求?
这是jsp页面<%@pagelanguage="java"import="java.util.*"pageEncoding="UTF-8"%><%@pageimport=...
这是jsp页面
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="com.jhqn.liansjk.dao.Hello" %>
<%@ page import="java.sql.Connection"
import ="java.sql.DriverManager" %>
<% request.setCharacterEncoding("UTF-8"); %>
<%
String path = request.getContextPath();
String basePath =request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'connDataBase.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--<link rel="stylesheet" type="text/css" href="styles.css">-->
</head>
<body>
This is my JSP page. <br>
<%
String userName=request.getParameter("userName");
String gender=request.getParameter("sex");
String age=request.getParameter("age");
String nickName=request.getParameter("nickName");
String password=request.getParameter("comfirmPass");
String email=request.getParameter("email");
Hello conns=new Hello();
conns.Showshujk(userName, password, nickName, age, gender, email);%>
</body>
</html>
这是java类
package com.jhqn.liansjk.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
public class Hello{
private Connection conn;
public void Showshujk(String userName, String password, String nickName,
String age, String gender, String email)
throws ClassNotFoundException, SQLException {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String dateBaseName = "Students";
String url = "jdbc:sqlserver://localhost:1433;DatabaseName="+ dateBaseName;
String usernames = "sa";
String passwords = "sa";
conn = DriverManager.getConnection(url, usernames, passwords);
System.out.println("数据库连接成功!!!!!");
/*String que = "select * from studentInfo ";
Statement pst = conn.createStatement();
//PreparedStatement pst = conn.prepareStatement(que);
ResultSet rs = pst.executeQuery(que);
//Columns cols=new Columns();
if (rs.next() == true) {
System.out.println("该用户已存在!");
} else {
String sql = "INSERT INTO studentInfo VALUES"+ "('"+ userName+ "','"+password
+ "','"+ nickName+ "',"+ gender+ ",'"+ gender+ "','"+ email+ "')";
pst.executeUpdate(sql);
System.out.println("恭喜您!注册成功!");}
rs.close();
pst.close();*/
conn.close();
}
} 展开
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="com.jhqn.liansjk.dao.Hello" %>
<%@ page import="java.sql.Connection"
import ="java.sql.DriverManager" %>
<% request.setCharacterEncoding("UTF-8"); %>
<%
String path = request.getContextPath();
String basePath =request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'connDataBase.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--<link rel="stylesheet" type="text/css" href="styles.css">-->
</head>
<body>
This is my JSP page. <br>
<%
String userName=request.getParameter("userName");
String gender=request.getParameter("sex");
String age=request.getParameter("age");
String nickName=request.getParameter("nickName");
String password=request.getParameter("comfirmPass");
String email=request.getParameter("email");
Hello conns=new Hello();
conns.Showshujk(userName, password, nickName, age, gender, email);%>
</body>
</html>
这是java类
package com.jhqn.liansjk.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
public class Hello{
private Connection conn;
public void Showshujk(String userName, String password, String nickName,
String age, String gender, String email)
throws ClassNotFoundException, SQLException {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String dateBaseName = "Students";
String url = "jdbc:sqlserver://localhost:1433;DatabaseName="+ dateBaseName;
String usernames = "sa";
String passwords = "sa";
conn = DriverManager.getConnection(url, usernames, passwords);
System.out.println("数据库连接成功!!!!!");
/*String que = "select * from studentInfo ";
Statement pst = conn.createStatement();
//PreparedStatement pst = conn.prepareStatement(que);
ResultSet rs = pst.executeQuery(que);
//Columns cols=new Columns();
if (rs.next() == true) {
System.out.println("该用户已存在!");
} else {
String sql = "INSERT INTO studentInfo VALUES"+ "('"+ userName+ "','"+password
+ "','"+ nickName+ "',"+ gender+ ",'"+ gender+ "','"+ email+ "')";
pst.executeUpdate(sql);
System.out.println("恭喜您!注册成功!");}
rs.close();
pst.close();*/
conn.close();
}
} 展开
2015-05-08 · 知道合伙人互联网行家
关注
展开全部
您好,您的报错信息有吗,贴出来帮你分析下啊,还有一般都用try,catch,如下:
try {
pst.executeUpdate(sql);// 执行SQL语句
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
pst.close();// 关闭Statement
} catch (SQLException e) {
e.printStackTrace();
}
try {
connection.close();// 关闭Connection
} catch (SQLException e) {
e.printStackTrace();
}
}
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询
广告 您可能关注的内容 |