Question

求个jsp程序，能对数据库实现增删改查，一定要是完整的哦！！内容随便！

考查课全睡过去，，只知道课程的最后作业这个题目，看各位大侠的了！！有的直接发我邮箱好了！！357769524@qq.com

Answer 1

数据库：Oracle（导入一个JDBC
jar包
oracle
安装包的Classes12.jar）
create
table
SUPER
(
NAME
VARCHAR2(20)
not
null,
PASS
VARCHAR2(20)
not
null,
)
alter
table
SUPER
add
primary
key
(NAME)
import
java.sql.*;
public
class
DbConnection
{
final
static
String
sConnStrDev
=
"jdbc:oracle:thin:@IP地址:端口号:数据库名称";
final
static
String
userNameDev
=
"用户名";
final
static
String
passwordDev
=
"密码";
public
static
Connection
getConnection(){
Connection
conn
=
null;
try{
Class.forName(sDBDriver);
conn
=
DriverManager.getConnection(sConnStrDev,
userNameDev,
passwordDev);
System.out.println(conn);
return
conn;
}catch(Exception
e){
e.printStackTrace();
}
return
null;
}
public
static
void
main(String[]
args)
throws
Exception{
DbConnection
dbcon
=
new
DbConnection();
Connection
conn
=
dbcon.getConnection();
//select
PreparedStatement
ps
=
conn.prepareStatement("select
*
from
super");
ResultSet
result
=
ps.executeQuery();
System.out.println(result);
while(result.next()){
String
schemeId
=
(String)(result.getObject(1));
System.out.println("schemeId:
"
+
schemeId);
}
ps.clearBatch();
//
insert
String
update1
=
"insert
into
super(name,
pass)
values('zhangming',
'boy')";
ps
=
conn.prepareStatement(update1);
int
b
=
ps.executeUpdate();
System.out.println(b);
//update
String
update2
=
"update
super
set
pass
=
'123'
where
name
=
'zhangming'";
ps
=
conn.prepareStatement(update2);
b
=
ps.executeUpdate();
System.out.println(b);
//delete
String
update3
=
"delete
super
where
name
=
'zhangming'";
ps
=
conn.prepareStatement(update3);
b
=
ps.executeUpdate();
System.out.println(b);
}
}