mysql 数据源配置_MySql数据源配置

1.tomcat的config/server.xml中将以下代码写到 前：

name="jdbc/demoDS">    

scope="Shareable"

type="javax.sql.DataSource"

factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"

url="jdbc:mysql://localhost:3306/test"   

driverClassName ="com.mysql.jdbc.Driver"

username="root"

password="123456"

/>

2.web.xml中引入数据源(三个参数顺序不能变，否则编译不通过)

jdbc/demoDS

javax.sql.DataSource

Container

3.写java代码连接

package util;

import java.sql.Connection;

public class Struts

{

protected javax.naming.Context ctx = new javax.naming.InitialContext();

protected javax.sql.DataSource ds;

protected Connection conn;

public Struts() throws Exception

{

ds = (javax.sql.DataSource) ctx.lookup("java:/comp/env/jdbc/demoDS");

conn = ds.getConnection();

}

}

4.应用示例代码，写一个查询函数

public List search() throws Exception

{

List result = new LinkedList();

String sql = "SELECT * FROM Stu_Course WHERE SNo='"

+ form.getCNo() +"'";

PreparedStatement pstmt =  conn.prepareStatement(sql);

ResultSet rs = pstmt.executeQuery();

while(rs.next())

{

String[] row = new String[4];

row[0] = rs.getString(1);

row[1] = rs.getString(2);

row[2] = String.valueOf(rs.getInt(3));

row[3] = rs.getString(4);

result.add(row);

}

rs.close();

conn.close();

return result;

}

蛋疼的，以前弄过就忘，再用到就有蛋疼一遍，记下来。。。