我的ava

最新推荐文章于 2021-07-16 16:20:07 发布

陈堃

最新推荐文章于 2021-07-16 16:20:07 发布

阅读量839

点赞数 1

本文链接：https://blog.csdn.net/kk18363852822/article/details/9445375

版权

package com.neusoft.utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbcOracleTest {

	/**
	 * @param args
	 */

	public static void main(String[] args) {

		// 2.建立同数据库的连接
		// url:统一资源定位符
		String url = "jdbc:oracle:thin:@10.25.85.247:1521:orcl";
		String user = "scott";
		String password = "tiger";
		Connection con = null;
		Statement st = null;
		String sql = "select * from DEPT";
		String sql1 = "delete from USERTEST";
		ResultSet rs = null;
		PreparedStatement pst = null;
		// 1.加载驱动
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			con = DriverManager.getConnection(url, user, password);
			System.out.println("数据库连接成功！");
			// 取消自动提交事务
			con.setAutoCommit(false);

			// 3.取得statement对象
			st = con.createStatement();
			// 4.发送statement到oracle中，并且查询表
			rs = st.executeQuery(sql);
			// 5.取出结果集中的数据
			while (rs.next()) {
				System.out.println("*************************");
				String deptno = rs.getString(1);
				System.out.println(deptno);
				String dname = rs.getString(2);
				System.out.println(dname);
				String loc = rs.getString(3);
				System.out.println(loc);
				System.out.println("*************************");
			}
			// 6.删除数据
			// int i = st.executeUpdate(sql1);
			// System.out.println("删除的记录的条数："+i);

			// 7.高级-->?占位符
			pst = con.prepareStatement("insert into USERTEST values(?,?,?)");
			// 给占位符赋值-->通过serXxx()方法
			pst.setString(1, "5");
			pst.setString(2, "u5");
			pst.setString(3, "p5");
			int i = pst.executeUpdate();
			System.out.println("插入的记录的条数：" + i);
			//事务处理-->提交
			con.commit();

		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			try {
				//事务处理-->回滚
				con.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		}

		// 6.关闭资源
		try {
			if (rs != null) {
				rs.close();
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			if (st != null) {
				st.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			if (pst != null) {
				pst.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			if (con != null) {
				con.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

<%@ 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>
  <script type="text/javascript">
 function test() {
  var name_1 = document.formData.password.value;
  if(name_1.length<6){
  alert("密码不足六位，重新输入");
  return false;
  }
  return true;
 }
</script>

 </head>
 <body>
  <form action="../servlet/LoginServlet" method="post" name="formData">
   用户名：
   <input type="text" name="username" value="neusoft" />
   <br>
   密码：&nbsp;&nbsp;
   <input type="password" name="password" value="123456">
   <br>
   <input type="submit" value="提交" οnclick="return test()">
   <input type="reset" value="重置">

  </form>
 </body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%
 String path = request.getContextPath();
 String basePath = request.getScheme() + "://"
   + request.getServerName() + ":" + request.getServerPort()
   + path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
 <head>
  <base href="<%=basePath%>">

  <title>My JSP 'index.jsp' starting page</title>
  <meta http-equiv="pragma" content="no-cache">
  <meta http-equiv="cache-control" content="no-cache">
  <meta http-equiv="expires" content="0">
  <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  <meta http-equiv="description" content="This is my page">
  <!--
 <link rel="stylesheet" type="text/css" href="styles.css">
 -->
 </head>

 <body>
  欢迎<font color="red">${ub.name}</font>登录本系统.
 </body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%
 String path = request.getContextPath();
 String basePath = request.getScheme() + "://"
   + request.getServerName() + ":" + request.getServerPort()
   + path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
 <head>
  <base href="<%=basePath%>">

  <title>My JSP 'index.jsp' starting page</title>
  <meta http-equiv="pragma" content="no-cache">
  <meta http-equiv="cache-control" content="no-cache">
  <meta http-equiv="expires" content="0">
  <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  <meta http-equiv="description" content="This is my page">
  <!--
 <link rel="stylesheet" type="text/css" href="styles.css">
 -->
 </head>

 <body>
  <a href="../index.jsp" target="main">登录</a>
  <br />
  <a href="url">增加</a>
  <br />
  <a href="url">删除</a>
  <br />
  <a href="url">修改</a>
  <br />

 </body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%
 String path = request.getContextPath();
 String basePath = request.getScheme() + "://"
   + request.getServerName() + ":" + request.getServerPort()
   + path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
 <head>
  <base href="<%=basePath%>">

  <title>My JSP 'index.jsp' starting page</title>
  <meta http-equiv="pragma" content="no-cache">
  <meta http-equiv="cache-control" content="no-cache">
  <meta http-equiv="expires" content="0">
  <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  <meta http-equiv="description" content="This is my page">
  <!--
 <link rel="stylesheet" type="text/css" href="styles.css">
 -->
 </head>

 <body>

 </body>
</html>

<html>
 <head></head>
 <frameset rows="20%,80%">
  <frame name="top" src="frame_a.jsp" framef="0">
  <frameset cols="20%,80%">
   <frame name="left" src="frame_b.jsp" scrolling=no noresize
    framespacing="0">
   <frame name="main" src="frame_c.jsp" bordercolor="red"
    marginwidth="100" marginheight="50" framespacing="0">
  </frameset>
  <body></body>
  </noframes>
 </frameset>
</html>

陈堃

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
我的ava

package com.neusoft.utils;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sq
复制链接

扫一扫