jsp连数据库入门测试

最新推荐文章于 2021-09-04 09:39:52 发布

maleizzia

最新推荐文章于 2021-09-04 09:39:52 发布

阅读量387

点赞数

分类专栏： javaweb

本文链接：https://blog.csdn.net/maleizzia/article/details/19614049

版权

javaweb 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="com.mysql.jdbc.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.sql.Connection"%>
<%
	//driver name
	String driverName = "com.mysql.jdbc.Driver";
	//database username
	String userName = "root";
	//password
	String userPwd = "root";
	//db name
	String dbName = "test";
	String tableName = "goods";
	//connection stirng
	String url = "jdbc:mysql://localhost/" + dbName + "?user=" + userName
			+ "&password=" + userPwd;
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	try{
	Connection conn = DriverManager.getConnection(url);out.print("connection db sucessfully");}
	catch(Exception e){out.print("connection db failure");}
	
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>
		<title>MySQLTest</title>
	</head>

	<body>
	</body>
</html>