jsp 连接mysql数据库,新建数据表,更新表数据...

时间：2010-08-10 来源：yunzaitian163

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>