db.java

ssh2整合.一个登陆页面,jdk5,tomcat5.5,hibernate3.1,spring2.1.struts2

package com.jxsme.gov.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class db {
	
	ResultSet rs2 = null;

	Connection conn2 = null;

	Statement stmt = null;
    
	String username = "root";//��ݿ���û�

	String password = "1234";//��ݿ����
/*
 * һЩSQL�﷨:
 * ����:"UPDATE  zjy_tb  SET content='4545',title='444eeee44' where id=1"
 * ���:insert  into zjy_tb ( id,title,content) values('9','�ƽ�','�ƽ�')
 * ɾ��:delete from zjy_tb where id='8'
 * ��Ѷ:select * from zjy_tb
 */
//	String strurl = "jdbc:mysql://localhost:3306/jxtv3";//�û�url
	String strurl="jdbc:mysql://localhost/ssh?user="+username+"&password="+password+"&useUnicode=true&characterEncoding=utf-8"; 
  //jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1" 
//��������