请教高手帮忙看一下这种做法可否行的通,谢谢
<html>
<head>
<title>
链接数据库
</title>
</head>
<body>
<form action="ex2.jsp" method="post">
<br>
账户名:
<input type="text" name="text1">
密码:
<input type="text" name="text2">
<br>
<input type="submit" name="submit">
</form>
</body>
</html>
<%@page language="java" contentType="text/html;charset=GB2312"%>
<%@import java.lang.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import javax.swing.*;
%>
<%! Connection ConnObj;//连接数据库所用变量
Statement SQLStatement;//连接数据库所用变量
ResultSet RS;//连接数据库所用变量%>
<%try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ConnObj=DriverManager.getConnection("jdbc:odbc:user");
SQLStatement=ConnObj.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
RS=SQLStatement.executeQuery("SELECT * FROM 表1");
}
catch (Exception ecp)
{
JOptionPane.showMessageDialog(this,ecp.getMessage());
}
}
%>
<%String name=request.getParameter("text1");
String password=request.getParameter("text2");
<%
String insertsql="insert into 表1(用户名,密码)"+"values('"+name+"','"+password+"')";
/*try
{
CurrentRow=RS.getRow();
}
catch(SQLException O)
{
}
name.requestFocus();*/
try
{
System.out.println(insertsql);
SQLStatement.executeUpdate(insertsql);
//JOptionPane.showMessageDialog(null, "成功插入数据");
}
catch(SQLException O)
{
}
CurrentRow=1;
%>