📄 test.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:news";
//orcl为你的数据库的SID
String user="system";
String password="manager";
String aa="manager";
String bb="system";
String cc="1";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//stmt.executeUpdate("INSERT INTO scott.aaa(a,b,id,numid,dateandtime) VALUES('"+aa+"','"+bb+"',scott.aid.nextval,'"+cc+"',sysdate)");
//stmt.executeUpdate("INSERT INTO scott.aaa(a,b,id,numid) VALUES('"+aa+"','"+bb+"','1','11')");
int dd=1;
//String sql="select * from scott.aaa where id="+dd;
String sql="select * from scott.learning where articleid="+dd;
ResultSet rs=stmt.executeQuery(sql);
if(!rs.next())
{
out.println("adddddddddd");
}
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString("a")%>
您的第二个字段内容为：<%=rs.getString("b")%>
<%out.println("a");
}%>
<%out.println("数据库操作成功，恭喜你");
out.println(sql);
%>
<%
//String sql1="delete from scott.aaa";
//ResultSet rs1=stmt.executeQuery(sql1);
//rs1.close();
rs.close();
stmt.close();
conn.close();
//如果加载时出错，给出相应的错误信息
//catch (Exception e) {
//System.out.println("error:"+e.getMessage());
//}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -