jsp 连接mysql数据库，新建数据表，更新表数据

最新推荐文章于 2022-06-06 00:52:36 发布

DrHSZhao

最新推荐文章于 2022-06-06 00:52:36 发布

阅读量5.2k

点赞数 2

文章标签：数据库 jsp mysql string import jdbc

本文链接：https://blog.csdn.net/yunzaitian163/article/details/5803326

版权

1,jsp建立数据表

<html>
<head>
</head>
<body>
<%@ page contentType="text/html; charset=gb2312" %>

<%@ page language="java" %>

<%@ page import="com.mysql.jdbc.Driver" %>

<%@ page import="java.sql.*" %>

<%

//驱动程序名

String driverName="com.mysql.jdbc.Driver";

//数据库用户名

String userName="root";

//密码

String userPasswd="root";

//数据库名

String dbName="test";

//表名

String tableName="user";

//联结字符串

String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;

Class.forName("com.mysql.jdbc.Driver").newInstance();

Connection connection=DriverManager.getConnection(url);

Statement statement = connection.createStatement();

String sql="create table haisen(id int)";

int rs = statement.executeUpdate(sql);

statement.close();

connection.close();

int tryint[]=new int[2];

tryint[0]=1;

tryint[1]=2;

%>
</body>
<script>
var aaatry="<%=rs%>";
alert(aaatry);
</script>

</html>
2，jsp向数据库中插入数据

<html>
<head>
</head>
<body>
<%@ page contentType="text/html; charset=gb2312" %>

<%@ page language="java" %>

<%@ page import="com.mysql.jdbc.Driver" %>

<%@ page import="java.sql.*" %>

<%

//驱动程序名

String driverName="com.mysql.jdbc.Driver";

//数据库用户名

String userName="root";

//密码

String userPasswd="root";

//数据库名

String dbName="test";

//表名

String tableName="user";

//联结字符串

String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;

Class.forName("com.mysql.jdbc.Driver").newInstance();

Connection connection=DriverManager.getConnection(url);

Statement statement = connection.createStatement();

String sql="insert table user values('2','haisen')";

int rs = statement.executeUpdate(sql);

statement.close();

connection.close();

int tryint[]=new int[2];

tryint[0]=1;

tryint[1]=2;

%>
</body>
<script>
var aaatry="<%=rs%>";
alert(aaatry);
</script>

</html>