4.11

avaweb功能的实现

首先是html界面

<h2>请登录</h2>
<form action="/UserLoginServlet" method="post">
<table>
<tr>
<td align="left">
用户名：
<input type="text" name="username" value="jiangnairi">
<br>
密&nbsp;码：
<input type="password" name="password" value="123456">
</td>
<td align="center">
<input type="submit" value="登录"><br>
<input type="reset" value="重置">
</td>
</tr>
</table>
</form>

然后是后台dao层面的建立

public int modifyData(String sql,Object obj[]) {//增删改
int result=0;
Connection conn=ConnMysql.getConn();
try {
PreparedStatement ps=conn.prepareStatement(sql);
for(int i=0;i<obj.length;i++) {
ps.setObject(i+1, obj[i]);
}
result=ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return result;
}



public static ResultSet getDataByAny(String sql,Object obj[]) {//查
Connection conn=ConnMysql.getConn();
ResultSet rs=null;
try {
PreparedStatement ps=conn.prepareStatement(sql);
for(int i=0;i<obj.length;i++) {
ps.setObject(i+1, obj[i]);
}
rs=ps.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return rs;
}

public static Connection getConn() {
Connection conn=null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/2022.3.4","root","111111");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;

}