软件工程概论作业1

1需要网站系统开发需要掌握的技术

1>html与css网页开发基础

2>jsp语言

3>javaBean技术

4>servlet技术

5>数据库的操作技术

2本次课堂测试的程序源代码

1）登陆页面：login.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=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="index.jsp" method="post">
登录页面<br>
账号<input type="text" name="name"/><br/>
密码<input type="password" name="psd">
<input type="submit"name="submit"value="登陆" >
</form>
</body>
</html>

2>连接数据库及判断账号密码界面 index.jsp

<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.sql.*" %>
<!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=GB18030">
<title>Insert title here</title>
</head>
<body>
<%
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433; DatabaseName=Test";
String username="sa";
String password="*******";

String user_name=request.getParameter("name");
String user_pass=request.getParameter("psd");
if(user_name==""||user_pass==""){
out.print("姓名或密码为空，请重新输入！");
}else{

Connection conn=DriverManager.getConnection(url, username, password);
if(conn!=null){
out.println("数据库连接成功！");

Statement sm =conn.createStatement(); //创建Statement

ResultSet rs=sm.executeQuery("select * from users where name='"+user_name+"'"+"and psd='"+user_pass+"'");
if(rs.next()){
response.sendRedirect("receive.jsp");
}else{
response.sendRedirect("error.jsp");
}

conn.close();
}else{
out.println("数据库连接失败！");
}
}
}catch(ClassNotFoundException e){
e.printStackTrace();
}
%>
</body>
</html>

3>登陆成功界面 receive.jsp

<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<!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=GB18030">
<title>Insert title here</title>
</head>
<body>
登陆成功
</body>
</html>

4>登陆失败界面 error.jsp

3.运行结果截图：

1>密码为空