jsp连数据库入门测试

来源:互联网 发布:淘宝高仿lv包 编辑:程序博客网 时间:2024/05/16 16:58
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%@ page import="com.mysql.jdbc.*"%><%@ page import="java.sql.*"%><%@ page import="java.sql.Connection"%><%//driver nameString driverName = "com.mysql.jdbc.Driver";//database usernameString userName = "root";//passwordString userPwd = "root";//db nameString dbName = "test";String tableName = "goods";//connection stirngString 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>

0 0
原创粉丝点击